Tabela WHPerfContract

Definicja tabeli WHPerfContract

Name

WHPerfContract

Code

WHPerfContract

Comment

 


Lista kolumn tabeli WHPerfContract

Name

Code

PersonID

PersonID

FullDT

FullDT

PointsCountSum7D

PointsCountSum7D

ValueSum7D

ValueSum7D

PointsCountSum30D

PointsCountSum30D

ValueSum30D

ValueSum30D

PointsCountSumThisMonth

PointsCountSumThisMonth

ValueSumThisMonth

ValueSumThisMonth

PointsCountSumThisYear

PointsCountSumThisYear

ValueSumThisYear

ValueSumThisYear

ICDCode

ICDCode


Kolumna PersonID tabeli WHPerfContract

Definicja kolumny PersonID tabeli WHPerfContract

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna FullDT tabeli WHPerfContract

Definicja kolumny FullDT tabeli WHPerfContract

Name

FullDT

Code

FullDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna PointsCountSum7D tabeli WHPerfContract

Definicja kolumny PointsCountSum7D tabeli WHPerfContract

Name

PointsCountSum7D

Code

PointsCountSum7D

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ValueSum7D tabeli WHPerfContract

Definicja kolumny ValueSum7D tabeli WHPerfContract

Name

ValueSum7D

Code

ValueSum7D

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna PointsCountSum30D tabeli WHPerfContract

Definicja kolumny PointsCountSum30D tabeli WHPerfContract

Name

PointsCountSum30D

Code

PointsCountSum30D

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ValueSum30D tabeli WHPerfContract

Definicja kolumny ValueSum30D tabeli WHPerfContract

Name

ValueSum30D

Code

ValueSum30D

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna PointsCountSumThisMonth tabeli WHPerfContract

Definicja kolumny PointsCountSumThisMonth tabeli WHPerfContract

Name

PointsCountSumThisMonth

Code

PointsCountSumThisMonth

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ValueSumThisMonth tabeli WHPerfContract

Definicja kolumny ValueSumThisMonth tabeli WHPerfContract

Name

ValueSumThisMonth

Code

ValueSumThisMonth

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna PointsCountSumThisYear tabeli WHPerfContract

Definicja kolumny PointsCountSumThisYear tabeli WHPerfContract

Name

PointsCountSumThisYear

Code

PointsCountSumThisYear

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ValueSumThisYear tabeli WHPerfContract

Definicja kolumny ValueSumThisYear tabeli WHPerfContract

Name

ValueSumThisYear

Code

ValueSumThisYear

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna ICDCode tabeli WHPerfContract

Definicja kolumny ICDCode tabeli WHPerfContract

Name

ICDCode

Code

ICDCode

Data Type

VARCHAR2(12)

Mandatory

Yes

Comment

 


Lista kluczy tabeli WHPerfContract

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli WHPerfContract

Definicja klucza Identifier_1 tabeli WHPerfContract

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment